package com.yxuan.springboot.mapper;

import com.yxuan.springboot.model.VolunteerFormDetails;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

import java.util.List;
import java.util.Map;

/**
 * 
 * @author zchao
 *    VolunteerFormDetailsMapper层
 * @date 2023-06-16 16:54:06
 */
@Mapper
public interface VolunteerFormDetailsMapper extends BaseMapper<VolunteerFormDetails> {


    List<Integer> findSchoolIdList(int form_id);

    List<Map> findschoolDetails(@Param("idList")List<Integer> idList);

    List<Map> findSchoolScore(String province, String school_name, @Param("lot_type") List<String> lot_type);

    List<Map> findProfessionScore(Integer school_id, String professional_name,String province,@Param("classificationList") List<String> classificationList);
}

